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