UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TXSRG9mbb0IvTcTZcC9cAyTvUloiyQc5f3FuMkPVU34='
WHERE
key_id = '095e642ad590ca0196310215f75d90ae16603d52d4c88a0df23d949094ee0999'
AND (
token = 'TXSRG9mbb0IvTcTZcC9cAyTvUloiyQc5f3FuMkPVU34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)