UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4jfGTtVHTaFCrE3qX/PFPYva/N67pMPjs39GeD2YfCo='
WHERE
key_id = '6b7d85a9b1f36108c1b2d71228b0c6ebd786198835ab00771880870b2683a286'
AND (
token = '4jfGTtVHTaFCrE3qX/PFPYva/N67pMPjs39GeD2YfCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)