UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V8QHA5S7EXZ7q8Jl5ibctlg6jnu+1hojvYqvg/XSL+c='
WHERE
key_id = '4397849ab8b07cef6eab74e8666586dab0a8b22759726ab27bb2597995e76ee4'
AND (
token = 'V8QHA5S7EXZ7q8Jl5ibctlg6jnu+1hojvYqvg/XSL+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)