UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1JxHPDKTS6NxybhE4xh4RzStxMswysQG7p04bYiFMQk='
WHERE
key_id = 'e55b112838f51b309cf25c2c98ce3099d8fd8974cb5607743757d73ff77b9fb9'
AND (
token = '1JxHPDKTS6NxybhE4xh4RzStxMswysQG7p04bYiFMQk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)