UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+zRbhunRd3PZzp+habI1qG8GERqBrRG1s08crlm2aA0='
WHERE
key_id = 'e7187c5f9f711e070dd9234c68d4e921831eb75f378def338ee04f81fce99d84'
AND (
token = '+zRbhunRd3PZzp+habI1qG8GERqBrRG1s08crlm2aA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)