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