UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hHSJ8AOo3Oo/966GWVkDYC1alZ9sIjYVxgGn+u+jZaE='
WHERE
key_id = '28abf015f3f8abae3819ab84b0c8a615e0b8d0872e751138511177fcc89d0154'
AND (
token = 'hHSJ8AOo3Oo/966GWVkDYC1alZ9sIjYVxgGn+u+jZaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)