UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6PcNOeOxY7zwM3bb9T5lBav8/gVRImSPiEiRGly6p+k='
WHERE
key_id = '6fb78720d9f622f1be3fe8619d2168bd5ad28dc7045f2ecafdc6c4faf8501fdc'
AND (
token = '6PcNOeOxY7zwM3bb9T5lBav8/gVRImSPiEiRGly6p+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)