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