UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x2STkQEFZmPqPboSjQwHM2ZwS5egLBpWY9llRCZJfK4='
WHERE
key_id = 'b67ea9013880a555b92f2a5a55646a8ee74a28b44a4ae22612cb412e4792050f'
AND (
token = 'x2STkQEFZmPqPboSjQwHM2ZwS5egLBpWY9llRCZJfK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)