UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QR/sWR9EoQaATY+pIpNaIsg1M/N5q2OgEttgqz/hHsg='
WHERE
key_id = '8b7948de17740c8d520f72276916bc9e54a6a24817996cfe54e913ed292ba4d1'
AND (
token = 'QR/sWR9EoQaATY+pIpNaIsg1M/N5q2OgEttgqz/hHsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)