UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nmVe1K6EjyfkIXPW7mMsyS7C+19PqAa36NJ58DzHoLE='
WHERE
key_id = '00edaaf9c07bd7bae412542a93d4b556c48e4056e3e6e8c15cd6e9fef697a992'
AND (
token = 'nmVe1K6EjyfkIXPW7mMsyS7C+19PqAa36NJ58DzHoLE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)