UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2qf5VzSlTjlFzqxaSUWsat9y5X1ayXq5jEtZU1D6jgI='
WHERE
key_id = '2a789b02a28c9f3fa82eceb9682222ef21e1ec4d2af0059c329d91a8998133af'
AND (
token = '2qf5VzSlTjlFzqxaSUWsat9y5X1ayXq5jEtZU1D6jgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)