UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JjAo88vwGM0xOPSwBzZ7BKEPKlFJR7gScsh3uX1KiCE='
WHERE
key_id = '78c7fca6aa573d6f360ac255d79287c3df16d9d541041687c6046744ef7816ad'
AND (
token = 'JjAo88vwGM0xOPSwBzZ7BKEPKlFJR7gScsh3uX1KiCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)