UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XtHsJauL5uzSs/eBW4iZYtwtJVlsL6gRlZVuotuUNE='
WHERE
key_id = 'a6facefccb30008ad03e821c92838255587b8aaf15f486224eed760c846026d5'
AND (
token = '/XtHsJauL5uzSs/eBW4iZYtwtJVlsL6gRlZVuotuUNE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)