UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nw9vPyOGzQ1HiFDWukdDTV3MMMGmA11B57qhnB34UUw='
WHERE
key_id = 'd264e2c40df00b113fdae43c1c05f3c8104c929dbf0cccaae5016c7061af595f'
AND (
token = 'Nw9vPyOGzQ1HiFDWukdDTV3MMMGmA11B57qhnB34UUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)