UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8D0qB2gsdUIwj+AQYoI8l1rsNuzLyzNN+9Lx9tjp7iI='
WHERE
key_id = '39c257872ba948ca91265858e2f9b035030df0290abef33219d0072dde6bed28'
AND (
token = '8D0qB2gsdUIwj+AQYoI8l1rsNuzLyzNN+9Lx9tjp7iI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)