UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KLfj14efKlTDAH7sB1WmAt/YP43012/Ax+gi9XZyJAU='
WHERE
key_id = '99e5d13a4e24af3630501a648a79e14eb1b31438965a8a3dd2c470a1b323e4be'
AND (
token = 'KLfj14efKlTDAH7sB1WmAt/YP43012/Ax+gi9XZyJAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)