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