UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OJ4hwoy3EoXsTj0Y/igbG22zwWVq3V5/sPCUTIUthrM='
WHERE
key_id = '1fb7d4cff2b48499e7b9cc52011fb946f9c3606e0a52af22807b769971c3b18d'
AND (
token = 'OJ4hwoy3EoXsTj0Y/igbG22zwWVq3V5/sPCUTIUthrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)