UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cB+PphHjZxJTJttvYqCtg0ALWQWe6QdcM2uDYH9Wric='
WHERE
key_id = '6b6331f8a51966426b950a2c2a43e7da2c2f441500107bb82af136eefb983010'
AND (
token = 'cB+PphHjZxJTJttvYqCtg0ALWQWe6QdcM2uDYH9Wric='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)