UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'buxuu2wwURDjXiBkcJMS+ykFJtyuZJYCSpZs2G6cSs0='
WHERE
key_id = 'e0a0834c228830a8ec87ac7f4c51674623ba5795406cbe94a1726df10ab441bc'
AND (
token = 'buxuu2wwURDjXiBkcJMS+ykFJtyuZJYCSpZs2G6cSs0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)