UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X5WKdMtD4WS0xHNhNI719bfnQmh9w3TME0fuIfB/BoY='
WHERE
key_id = '38d41019a68dd7476e636ca30e2c504e17a8245523d96f4e72380ab56b81ab4c'
AND (
token = 'X5WKdMtD4WS0xHNhNI719bfnQmh9w3TME0fuIfB/BoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)