UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dPDd/9AGcBZuuyoTM0olLldtEl6tO4/KZ2Cjwsr0D9E='
WHERE
key_id = '423df2c79818e57e5aa94bc26f1694f3f1ebcac70ed873b42fb05cd46c354890'
AND (
token = 'dPDd/9AGcBZuuyoTM0olLldtEl6tO4/KZ2Cjwsr0D9E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)