UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T8ir64jyRBl2IkknHKau49laCbIiy/il3zG0PIN4Xwk='
WHERE
key_id = '2dded39dd35fb0517d53ffb5bc2dd957217f59f68f77bf448038cad87e7a9838'
AND (
token = 'T8ir64jyRBl2IkknHKau49laCbIiy/il3zG0PIN4Xwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)