UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ddo0acWKWpQcXqC2mrUGjM7hVMT5mj406eM0KOGaPjs='
WHERE
key_id = 'd886e7b2bd36e64fe297b3286de33312ae3bdc5778e8292456c3b47080a1bf11'
AND (
token = 'ddo0acWKWpQcXqC2mrUGjM7hVMT5mj406eM0KOGaPjs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)