UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'soeAlqinsBRoP9upmhrqPI0OUxzskyI6+zWsyln3vcM='
WHERE
key_id = 'd83cee6328363d5e2a0fc6bab2b523458721e5d8c0da7c1e5878288eba66777d'
AND (
token = 'soeAlqinsBRoP9upmhrqPI0OUxzskyI6+zWsyln3vcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)