UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W179ohDWISVkOkqexeT4Uc/KkBhR02bf1RI98clngJs='
WHERE
key_id = '07ecd3fc4b5ac6000cef9031e270abe16f329953108f3d98eb7da709677862a5'
AND (
token = 'W179ohDWISVkOkqexeT4Uc/KkBhR02bf1RI98clngJs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)