UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QH4hpZuy2IugXEh3Moan31lxNprbwvg/liSvnIymlKY='
WHERE
key_id = 'c1ae979b35faa9ec5b2397323a4bfd8a22512b883cd7f8c2c6a1ce1f4bacaeb4'
AND (
token = 'QH4hpZuy2IugXEh3Moan31lxNprbwvg/liSvnIymlKY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)