UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6GhsBkhp3EwqWc3gDArUx3T/LirNSQR3Ar5F76aaBLk='
WHERE
key_id = '1cfc0abeccf703f02c6b62ef58e70f9fd1b250d05c143dbafe9f6f1d778470fe'
AND (
token = '6GhsBkhp3EwqWc3gDArUx3T/LirNSQR3Ar5F76aaBLk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)