UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xMwCxjgKVB+RaeK5sLOUmTOiZSBE6447orgetxUrvpk='
WHERE
key_id = 'bc931dc0506bdc50c6697b5bf01a0848f66f30994909e097c1ac7234bfb4c692'
AND (
token = 'xMwCxjgKVB+RaeK5sLOUmTOiZSBE6447orgetxUrvpk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)