UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P0MmzDJWv4wQhfs/ITpmhrjanWegaDLbPTmd+SdE/zU='
WHERE
key_id = 'a7bfbbe5bb43fa17702b05a4957c24b4dc6dc4c7e4ba45287eae55584b6d1230'
AND (
token = 'P0MmzDJWv4wQhfs/ITpmhrjanWegaDLbPTmd+SdE/zU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)