UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PJ54Ib1x5aMMMdHvTKKINfTHhzXZ99LAyLZ7UD+1bhk='
WHERE
key_id = '31d7cb443308f4b00c839c06b52559599675761c0b24200deed82c9001c526a1'
AND (
token = 'PJ54Ib1x5aMMMdHvTKKINfTHhzXZ99LAyLZ7UD+1bhk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)