UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Bv+h2RYbExagxK1+BnZsQwENl5OSPeo+L8fTxCPxY4='
WHERE
key_id = 'cf89a23901812bdedcd977f92314340bc528b51051d57087b4b5cea2fdf66e99'
AND (
token = '0Bv+h2RYbExagxK1+BnZsQwENl5OSPeo+L8fTxCPxY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)